4-Stage Agent Monthly Reporting Flow

✅ System Status: Tested and validated on Cif for Homecare UK monthly reporting workflow

📊 Process Overview

AI Agents

User Checkpoints

Manual Steps

15-25

Minutes Total

🔄 Process Flow Diagram

graph TD Start([👤 User: Extract Monthly Data
from Meltwater]) --> Agent1 Agent1[🤖 STAGE 1: Data Mapper Agent
Maps CSV columns to required fields
Validates data structure] Agent1 --> Check1{👤 User Checkpoint 1
Review mapped data
Provide feedback?} Check1 -->|✓ Approve & Continue| Agent2 Check1 -->|💬 Add Feedback/Changes| Agent1 Agent2[🤖 STAGE 2: Input Collector Agent
Gathers brand context & goals
Discovers logo/assets] Agent2 --> Manual1[📋 MANUAL STEP
User collects embed links
Agent provides post links for speed] Manual1 --> Manual2[🖼️ MANUAL STEP
User uploads logo
Or provides URL/uses discovery] Manual2 --> Check2{👤 User Checkpoint 2
Review inputs & assets
Provide feedback?} Check2 -->|✓ Approve & Continue| Agent3 Check2 -->|💬 Add Feedback/Changes| Agent2 Agent3[🤖 STAGE 3: Strategy Writer Agent
Analyses data & trends
Generates insights & recommendations
Creates strategic narrative] Agent3 --> Check3{👤 User Checkpoint 3
Review strategy content
Provide feedback?} Check3 -->|✓ Approve & Continue| Agent4 Check3 -->|💬 Add Feedback/Changes| Agent3 Agent4[🤖 STAGE 4: Report Builder Agent
Generates HTML report
Integrates embeds & branding
Produces downloadable file] Agent4 --> Check4{👤 User Checkpoint 4
Review final report
Request changes?} Check4 -->|✓ Approve - Report Complete| End([✅ Monthly Report Delivered
Ready for client presentation]) Check4 -->|💬 Request Revisions| Agent4 style Start fill:#e1f5ff style End fill:#d4edda style Agent1 fill:#fff3cd style Agent2 fill:#fff3cd style Agent3 fill:#fff3cd style Agent4 fill:#fff3cd style Manual1 fill:#f8d7da style Manual2 fill:#f8d7da style Check1 fill:#e7e7ff style Check2 fill:#e7e7ff style Check3 fill:#e7e7ff style Check4 fill:#e7e7ff

📋 Detailed Stage Breakdown

💡 How to use this guide: Click on each stage below to expand details. Each stage includes what happens, what you need to do, and expected outcomes.

📥

Initial Setup: Data Extraction

Extract monthly data from Meltwater (one-time per report)

▶

What You Do:

Log into Meltwater
Export monthly social media data (CSV or Excel format)
Upload file to agent system

Expected Outcome:

Data file successfully uploaded
System ready to begin agent processing

🤖

Stage 1: Data Mapper Agent

Automated column mapping and data validation

STAGE 1 ▶

What the Agent Does:

Intelligently maps CSV columns to required report fields
Validates data structure and completeness
Identifies platform types (Facebook, Instagram, LinkedIn, etc.)
Cleans and standardises data formats
Generates data quality report

Processing Time:

2-3 minutes (automated)

👤

Checkpoint 1: Review Mapped Data

Your approval required to proceed

CHECKPOINT 1 ▶

What You Do:

Review the data mapping summary
Check that platforms are correctly identified
Verify key metrics are mapped correctly
Decision: Approve and continue OR provide feedback for adjustments

Your Options:

✅ Approve: System proceeds to Stage 2
💬 Feedback: Agent refines mapping based on your input (no automatic recursion)

🤖

Stage 2: Input Collector Agent

Gathers brand context, goals, and asset requirements

STAGE 2 ▶

What the Agent Does:

Requests brand information and reporting goals
Identifies top-performing posts from data
Generates direct post URLs for embed collection
Attempts to discover logo assets (URL or uploaded)
Collects any additional context you provide

Processing Time:

Initial agent work: 2-3 minutes
With manual steps: 5-10 minutes total

📋

Manual Step: Collect Embed Links

Action required: Gather social media embed codes

MANUAL ▶

⚠️ Manual Action Required

What You Do:

Agent provides direct links to top-performing posts
Visit each platform (Facebook, Instagram, LinkedIn, etc.)
Copy embed code for each post
Paste embed codes back into system

Why Manual?

Platform APIs don't provide embed codes automatically
Requires authentication to specific accounts
Agent speeds up process by providing direct post URLs

🖼️

Manual Step: Upload Brand Logo

Action required: Provide brand assets

MANUAL ▶

⚠️ Manual Action Required

What You Do (Choose One Option):

Option 1: Upload logo file directly
Option 2: Provide logo URL (if publicly accessible)
Option 3: Let agent attempt asset discovery (testing phase)

Accepted Formats:

PNG (recommended for transparency)
JPG/JPEG
SVG (vector format, ideal for scaling)

👤

Checkpoint 2: Review Inputs & Assets

Your approval required to proceed

CHECKPOINT 2 ▶

What You Do:

Review collected brand information
Verify embed links are correct and working
Confirm logo appears correctly
Add any additional context or goals
Decision: Approve and continue OR provide feedback

Your Options:

✅ Approve: System proceeds to Stage 3
💬 Feedback: Agent collects additional inputs or corrections

🤖

Stage 3: Strategy Writer Agent

Generates insights, analysis, and strategic recommendations

STAGE 3 ▶

What the Agent Does:

Analyses performance data across all platforms
Identifies trends, patterns, and anomalies
Generates strategic insights and recommendations
Creates narrative content for executive summary
Develops platform-specific analysis
Produces actionable next steps and optimisation suggestions

Processing Time:

3-5 minutes (automated)

Output Includes:

Executive summary
Platform performance breakdown
Key wins and challenges
Strategic recommendations
Month-over-month comparisons (if data available)

👤

Checkpoint 3: Review Strategy Content

Your approval required to proceed

CHECKPOINT 3 ▶

What You Do:

Review the strategic narrative and insights
Verify recommendations align with client goals
Check data interpretation for accuracy
Assess tone and messaging
Decision: Approve and continue OR request revisions

Your Options:

✅ Approve: System proceeds to Stage 4 (report building)
💬 Feedback: Agent refines strategy content based on your input

Common Adjustments:

Tone modifications (more formal/casual)
Additional context or nuance
Emphasis on specific metrics or insights
Client-specific terminology adjustments

🤖

Stage 4: Report Builder Agent

Generates professional HTML report with branding and embeds

STAGE 4 ▶

What the Agent Does:

Generates interactive HTML report from template
Integrates all brand assets (logo, colours)
Embeds social media posts with live previews
Creates data visualisations and charts
Formats all content for professional presentation
Produces downloadable HTML file

Processing Time:

2-4 minutes (automated)

Report Features:

Responsive design (desktop, tablet, mobile)
Interactive charts and metrics
Live social media embeds
Print-optimised layout
Professional branding throughout
Client-ready presentation format

👤

Checkpoint 4: Final Report Review

Your final approval before delivery

CHECKPOINT 4 ▶

What You Do:

Download and open the generated HTML report
Review entire report for quality and accuracy
Check all embeds load correctly
Verify branding is consistent
Test across different devices/browsers if needed
Decision: Approve for delivery OR request final revisions

Your Options:

✅ Approve: Report is finalised and ready for client delivery
💬 Request Revisions: Agent rebuilds report with adjustments

Quality Checklist:

All data accurate and properly formatted
Social embeds displaying correctly
Logo and branding consistent
No spelling or grammar errors
Charts and visualisations clear and readable
Report renders properly on all devices

✅

Final Delivery: Report Complete

Ready for client presentation

▶

✅ Monthly Report Complete!

What You Have:

Professional HTML report (downloadable)
Client-ready presentation format
Interactive embeds and visualisations
Strategic insights and recommendations
Branded, polished deliverable

Delivery Options:

Email HTML file directly to client
Upload to shared drive or portal
Present live during client meetings
Export to PDF if preferred (print functionality)

⏱️ Typical Timeline

Total Process: 15-25 Minutes

2-3 min

Stage 1: Data Mapping (automated)

1 min

Checkpoint 1: Review & approve

5-10 min

Stage 2: Input collection + manual steps (embeds & logo)

1 min

Checkpoint 2: Review & approve

3-5 min

Stage 3: Strategy writing (automated)

1-2 min

Checkpoint 3: Review & approve

2-4 min

Stage 4: Report building (automated)

2-3 min

Checkpoint 4: Final review & approval

💡 Time-Saver: This represents an 85-90% time reduction compared to manual report creation, which typically takes 2-3 hours per monthly report.

🎯 Key Benefits for SMMs

💰 Token-Efficient

Less than 200K tokens per complete report keeps costs low whilst maintaining quality output.

✋ User-Controlled

Four checkpoints mean you maintain full control and quality oversight throughout the process.

🎨 Brand Flexibility

Add context, feedback, and client-specific nuances at every stage for personalised reports.

⚡ Speed & Efficiency

Complete professional reports in 15-25 minutes vs. 2-3 hours manual work.

🚫 No Recursion

Controlled iteration prevents endless loops—you approve each step before the system proceeds.

📊 Data-Driven

AI analyses patterns and generates insights you might miss in manual reviews.

🛠️ System Architecture

⚙️

Technical Overview

4-Agent Framework:

Data Mapper Agent: Python-based CSV/Excel processing with intelligent column detection
Input Collector Agent: Contextual information gathering with asset discovery
Strategy Writer Agent: Natural language generation with data analysis capabilities
Report Builder Agent: HTML template engine with embed integration

Key Components:

Python script: data_mapper.py for data transformation
HTML template: report_template.html with interactive features
Embed extraction logic for social platforms
Report generation and file download capabilities

Model Optimisation:

Cost-optimised model selection per agent
Token limits prevent runaway costs
Quality-speed-cost balance for each processing stage

Smart Data Discovery:

Supports CSV, Excel, and Google Sheets formats
Automatic column mapping with high accuracy
Data validation and quality checks

✅ Testing & Validation

Real-World Testing: This system has been successfully tested and validated on monthly reporting for Cif (Homecare UK), demonstrating:

Accurate data mapping from Meltwater exports
Quality strategic insights aligned with brand objectives
Professional report output suitable for client presentation
Significant time savings vs. manual report creation
User satisfaction with checkpoint control system

📞 Support & Questions

Need help during the process? The system includes built-in guidance at each checkpoint, but you can always request additional support or clarification at any stage.